Creating a Drill Query

Create a drill query either by dragging the Drill Query tool onto a segment or by selecting New > Drill Query.

Procedure

1. From the Data Explorer pane select your column and drag it onto the Drill Query.

2. Equals appears as the default operator. Click the drop-down arrow next to select a different operator.

Drill Query only supports combinations of AND between elements, and will therefore only display contextually supported operators for each column types

TEXT: =, <>, Like, IN, EQ, NE

OTHERS: =, <>, >, <, >=, <=, Between, IN, EQ, NE, LT, GT, LE, GE

3. Select your query criteria, by clicking in the box next to your operator. The values available for that column are shown.
4. Select a value by clicking on the Count and then the icon. Note that you can add more than one value to your selection in this way.
5. Click off the value selection box.
6. To add more columns to a drill query, Repeat steps one to five.

You will see a change in the count for the row above when you have added new columns, for example:

When all columns have been added, click Run to see the final count.

If you make any amendments to the columns used within the Drill Query, for example deleting a column then this will blank the values and counts of any rows underneath the amended column. For example:

• Drill Query
  • Creating a Drill Query
  • Opening a Drill Query as a Segment
  • Using Drill Query in a Segment
  • Training video - Using a Drill Query in a Query Form